from sqlalchemy import Column
from sqlalchemy.dialects.oracle import VARCHAR2, NUMBER
from sqlalchemy.orm import relationship
from app.db.base import Base

# Program Lookup Table
class ProgramLookup(Base):
    __tablename__ = 'PROGRAM_LOOKUP'
    __table_args__ = {'schema': 'COOP_APP'}

    program_lookup_id   = Column(NUMBER, primary_key=True)
    program_lookup_code = Column(VARCHAR2(10), nullable=False)
    faculty             = Column(VARCHAR2(100), nullable=True)
    co_op_program       = Column(VARCHAR2(100), nullable=True)
    program_length      = Column(NUMBER(1), nullable=True)

